package com.ahorresas.modelo.sqls;

public class DetalleAhorroSql {
    
    String sql = "";
    
    public String buscarDetalleAhorro(){
        sql = "SELECT id_detalle, id_ahorro, mes, valor_ahorro "
            + "FROM DETALLE_AHORROS "
            + "WHERE id_detalle = ?";
        return sql;
    }
    
    public String listarDetalleAhorros(){
        sql = "SELECT id_detalle, id_ahorro, mes, valor_ahorro "
            + "FROM DETALLE_AHORROS;";
        return sql;
    }
    
    public String crearDetalleAhorro(){
        sql = "INSERT INTO DETALLE_AHORROS (id_ahorro, mes, valor_ahorro ) "
            + "VALUES (?,?,?);";
        return sql;
    }
    
    public String modificarDetalleAhorro(){
        sql = "UPDATE DETALLE_AHORROS SET id_ahorro = ?, mes = ?, valor_ahorro = ? "
            + "WHERE id_detalle = ?;";
        return sql;
    }
    
    public String eliminarDetalleAhorro(){
        sql = "DELETE FROM DETALLE_AHORROS "
            + "WHERE id_detalle = ?;";
        return sql;
    }
    
}